﻿<%@ Page Title="View Car Capactiy" Language="C#" MasterPageFile="~/Admin/AdminMasterPage.master"
    AutoEventWireup="true" CodeFile="ViewProviderCarInsuranceSelectDetails.aspx.cs"
    Inherits="Provider_CarInsurance_ViewProviderCarInsuranceSelectDetails" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <div class="contents">
        <table width="100%" cellpadding="3" cellspacing="0" border="0">
            <tr>
                <td>
                    <h1>
                        Car Insurance User Select History Deails</h1>
                </td>
            </tr>
            <tr>
                <td>
                    <%--<b>Transaction Type</b> :
                    <asp:DropDownList ID="ddlTransType" runat="server">
                        <asp:ListItem Value="0">All</asp:ListItem>
                        <asp:ListItem Value="1">New</asp:ListItem>
                        <asp:ListItem Value="2">Update</asp:ListItem>
                        <asp:ListItem Value="3">Delete</asp:ListItem>
                    </asp:DropDownList>--%>
                    <b>Cover Type</b> :
                    <asp:DropDownList ID="ddlCXCoverageType" runat="server">
                    </asp:DropDownList>
                    &nbsp;<b>Date</b> :<asp:DropDownList ID="ddlYear" runat="server">
                        <asp:ListItem Value="0000">All</asp:ListItem>
                        <asp:ListItem Value="2010">2010</asp:ListItem>
                        <asp:ListItem Value="2011">2011</asp:ListItem>
                        <asp:ListItem Value="2012">2012</asp:ListItem>
                        <asp:ListItem Value="2013">2013</asp:ListItem>
                    </asp:DropDownList>
                    <asp:DropDownList ID="ddlMonth" runat="server">
                        <asp:ListItem Value="00">All</asp:ListItem>
                        <asp:ListItem Value="01">Jan</asp:ListItem>
                        <asp:ListItem Value="02">Feb</asp:ListItem>
                        <asp:ListItem Value="03">Mar</asp:ListItem>
                        <asp:ListItem Value="04">Apr</asp:ListItem>
                        <asp:ListItem Value="05">May</asp:ListItem>
                        <asp:ListItem Value="06">Jun</asp:ListItem>
                        <asp:ListItem Value="07">Jul</asp:ListItem>
                        <asp:ListItem Value="08">Aug</asp:ListItem>
                        <asp:ListItem Value="09">Sep</asp:ListItem>
                        <asp:ListItem Value="10">Oct</asp:ListItem>
                        <asp:ListItem Value="11">Nov</asp:ListItem>
                        <asp:ListItem Value="12">Dec</asp:ListItem>
                    </asp:DropDownList>
                    <asp:DropDownList ID="ddlDay" runat="server" ToolTip="Choose Day">
                        <asp:ListItem Value="00">All</asp:ListItem>
                        <asp:ListItem Value="01">01</asp:ListItem>
                        <asp:ListItem Value="02">02</asp:ListItem>
                        <asp:ListItem Value="03">03</asp:ListItem>
                        <asp:ListItem Value="04">04</asp:ListItem>
                        <asp:ListItem Value="05">05</asp:ListItem>
                        <asp:ListItem Value="06">06</asp:ListItem>
                        <asp:ListItem Value="07">07</asp:ListItem>
                        <asp:ListItem Value="08">08</asp:ListItem>
                        <asp:ListItem Value="09">09</asp:ListItem>
                        <asp:ListItem>10</asp:ListItem>
                        <asp:ListItem>11</asp:ListItem>
                        <asp:ListItem>12</asp:ListItem>
                        <asp:ListItem>13</asp:ListItem>
                        <asp:ListItem>14</asp:ListItem>
                        <asp:ListItem>15</asp:ListItem>
                        <asp:ListItem>16</asp:ListItem>
                        <asp:ListItem>17</asp:ListItem>
                        <asp:ListItem>18</asp:ListItem>
                        <asp:ListItem>19</asp:ListItem>
                        <asp:ListItem>20</asp:ListItem>
                        <asp:ListItem>21</asp:ListItem>
                        <asp:ListItem>22</asp:ListItem>
                        <asp:ListItem>23</asp:ListItem>
                        <asp:ListItem>24</asp:ListItem>
                        <asp:ListItem>25</asp:ListItem>
                        <asp:ListItem>26</asp:ListItem>
                        <asp:ListItem>27</asp:ListItem>
                        <asp:ListItem>28</asp:ListItem>
                        <asp:ListItem>29</asp:ListItem>
                        <asp:ListItem>30</asp:ListItem>
                        <asp:ListItem>31</asp:ListItem>
                    </asp:DropDownList>
                    Is Complete :
                    <asp:DropDownList ID="ddlStatus" runat="server">
                        <asp:ListItem Value="0">All</asp:ListItem>
                        <asp:ListItem Value="1">Complete</asp:ListItem>
                        <asp:ListItem Value="2">InComplete</asp:ListItem>
                    </asp:DropDownList>
                    <div style="display: none">
                        <asp:TextBox ID="txtModifiedDate" runat="server"></asp:TextBox>
                        <asp:TextBox ID="txtCompanyId" Text="0" runat="server"></asp:TextBox>
                        <asp:TextBox ID="txtIsComplete" Text="0" runat="server"></asp:TextBox></div>
                    <%--<b>Who</b> :
                    <asp:DropDownList ID="ddlProviderName" runat="server" OnSelectedIndexChanged="ddlProviderName_SelectedIndexChanged"
                        AutoPostBack="True">
                    </asp:DropDownList>
                    <div style="display: none">
                        <asp:DropDownList ID="ddlProviderId" runat="server">
                        </asp:DropDownList>
                    </div>
                    <asp:Label ID="lblProviderEmailAddress" runat="server"></asp:Label>--%>
                    &nbsp;<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Refresh Result" />
                </td>
            </tr>
            <tr>
                <td>
                    <asp:GridView ID="grvCarInsuranceResult" runat="server" AllowPaging="True" AllowSorting="false"
                        PageSize="30" AutoGenerateColumns="False" DataKeyNames="CECarID, CISelectItemId, RefCEUserId"
                        CellSpacing="3" CellPadding="3" Width="100%" CssClass="admin_gridstyle" PagerStyle-CssClass="pgr"
                        EmptyDataText="There are no data records to display." GridLines="None" DataSourceID="sqlDsCarInsuranceResult"
                        OnRowDataBound="grvCarInsuranceResult_RowDataBound" OnRowCommand="grvCarInsuranceResult_RowCommand"
                        OnSelectedIndexChanged="grvCarInsuranceResult_SelectedIndexChanged">
                        <Columns>
                            <%--<asp:BoundField DataField="CITempResultLogId" HeaderText="CITempResultLogId" Visible="false" />--%>
                            <asp:BoundField DataField="CECarId" HeaderText="CECarId" Visible="false" />
                            <asp:BoundField DataField="CISelectItemId" HeaderText="CISelectItemId" Visible="false" />
                            <asp:BoundField DataField="CXCoverTypeId" HeaderText="CXCoverTypeId" Visible="false" />
                            <%--<asp:BoundField DataField="ProviderCompanyId" HeaderText="ProviderCompanyId" Visible="false" />--%>
                            <%--<asp:ImageField DataImageUrlField="CompanyLogoUrl" Visible="false" HeaderText="Insurer" SortExpression="InsurerName" />--%>
                            <%--                <asp:BoundField DataField="InsurerName" Visible="false" HeaderText="Company Name"
                                SortExpression="InsurerName" />--%>
                            <asp:TemplateField HeaderText="SurName" SortExpression="SurName">
                                <ItemTemplate>
                                    <asp:Label ID="lblSurName" runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="NRIC/Passport" SortExpression="First Name">
                                <ItemTemplate>
                                    <asp:Label ID="lblIDNO" runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="MakeModelDesc" HeaderText="MakeModelDesc" SortExpression="MakeModelDesc" />
                            <asp:BoundField DataField="AnnualPremium" DataFormatString="{0:c}" HeaderText="Annual Premium (+ GST)"
                                SortExpression="AnnualPremium" />
                            <asp:BoundField DataField="Excess" DataFormatString="${0:#,0}" HeaderStyle-Width="60"
                                HeaderText="Excess" SortExpression="Excess">
                                <HeaderStyle Width="60px"></HeaderStyle>
                            </asp:BoundField>
                            <asp:BoundField DataField="PlanName" Visible="true" HeaderText="Workshop Plan" SortExpression="CXCoverTypeId" />
                            <asp:CommandField ShowSelectButton="True" SelectText="View Details" />
                        </Columns>
                        <FooterStyle />
                        <PagerStyle />
                        <SelectedRowStyle />
                        <HeaderStyle CssClass="admin_gridheader" />
                        <EditRowStyle />
                        <AlternatingRowStyle CssClass="admin_gridodd" />
                        <RowStyle CssClass="admin_grideven" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="sqlDsCarInsuranceResult" runat="server" ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>"
                        SelectCommand="sprocCarInsuranceSelectItemSelectItemList" SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="txtCompanyId" Name="ProviderCompanyId" PropertyName="Text"
                                Type="Int64" />
                            <asp:ControlParameter ControlID="txtIsComplete" Name="IsComplete" PropertyName="Text"
                                Type="Int32" />
                            <asp:ControlParameter ControlID="ddlCXCoverageType" Name="CXCoverTypeId" PropertyName="SelectedValue"
                                Type="Int32" />
                            <asp:ControlParameter ControlID="txtModifiedDate" Name="ModifiedDate" PropertyName="Text"
                                Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                    <hr />
                    <asp:GridView ID="grvCarInsurancePackageDetail" runat="server" AllowPaging="True"
                        AllowSorting="false" PageSize="30" AutoGenerateColumns="False" CellSpacing="3"
                        CellPadding="3" Width="100%" CssClass="admin_gridstyle" PagerStyle-CssClass="pgr"
                        DataKeyNames="CISelectItemId" EmptyDataText="There are no data records to display."
                        GridLines="None" DataSourceID="sqlDsCarInsurancePackage" OnRowDataBound="grvCarInsurancePackageDetail_RowDataBound">
                        <Columns>
                            <%--<asp:BoundField DataField="CITempResultLogId" HeaderText="CITempResultLogId" Visible="false" />
                            --%>
                            <asp:BoundField DataField="CISelectItemId" HeaderText="CISelectItemId" Visible="false" />
                            <asp:BoundField DataField="CECarId" HeaderText="CECarId" Visible="false" />
                            <asp:BoundField DataField="CXCoverTypeId" HeaderText="CXCoverTypeId" Visible="false" />
                            <%--<asp:BoundField DataField="ProviderCompanyId" HeaderText="ProviderCompanyId" Visible="false" />--%>
                            <%--<asp:ImageField DataImageUrlField="CompanyLogoUrl" Visible="false" HeaderText="Insurer" SortExpression="InsurerName" />--%>
                            <%--                <asp:BoundField DataField="InsurerName" Visible="false" HeaderText="Company Name"
                                SortExpression="InsurerName" />--%>
                            <asp:BoundField DataField="AnnualPremium" DataFormatString="{0:c}" HtmlEncode="false"
                                HeaderText="Annual<br/>Premium<br/><span class='grid_font'>(+ GST)</span>" SortExpression="AnnualPremium" />
                            <asp:BoundField DataField="Excess" DataFormatString="${0:#,0}" HeaderStyle-Width="60"
                                HeaderText="Excess" SortExpression="Excess">
                                <HeaderStyle Width="60px"></HeaderStyle>
                            </asp:BoundField>
                            <asp:BoundField DataField="PlanName" Visible="true" HeaderText="Workshop Plan" SortExpression="CXCoverTypeId" />
                            <asp:BoundField DataField="PolicyHolder" DataFormatString="${0:#,0}" HeaderStyle-Width="80"
                                HtmlEncode="false" HeaderText="Personal<br/>Accident<br/><span class='grid_font'>(Named Driver/s)</span>"
                                SortExpression="PolicyHolder">
                                <HeaderStyle Width="80px"></HeaderStyle>
                            </asp:BoundField>
                            <asp:BoundField DataField="PassengerEach" DataFormatString="${0:#,0}" HeaderStyle-Width="80"
                                HtmlEncode="false" HeaderText="Personal<br/>Accident<br/><span class='grid_font'>(Each Passenger)</span>"
                                SortExpression="PassengerEach">
                                <HeaderStyle Width="80px"></HeaderStyle>
                            </asp:BoundField>
                            <asp:TemplateField HeaderText="Medical Expense" SortExpression="MedicalExpense">
                                <ItemTemplate>
                                    <div>
                                        <asp:Image ID="imgMedicalExpense" runat="server" ImageUrl="~/images/icons/X.gif" />
                                    </div>
                                    <div>
                                        <asp:Label ID="lblMedicalExpense" runat="server" Text="" />
                                    </div>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="CashAllowance" Visible="false" HeaderText="" SortExpression="CashAllowance" />
                            <asp:TemplateField HeaderText="Loss of Use<br/><span class='grid_font'>(Cash)</span>"
                                SortExpression="CashAllowance">
                                <ItemTemplate>
                                    <div>
                                        <asp:Image ID="imgCashAllowance" runat="server" ImageUrl="~/images/icons/X.gif" />
                                    </div>
                                    <div>
                                        <asp:Label ID="lblCashAllowance" runat="server" Text="" />
                                    </div>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="IsCarReplacement" Visible="false" HeaderText="Car Replacement" />
                            <asp:TemplateField HeaderText="Loss of Use<br/><span class='grid_font'>(Car Replacement)</span>"
                                SortExpression="CarReplacement">
                                <ItemTemplate>
                                    <div>
                                        <asp:Image ID="imgCarReplacement" runat="server" ImageUrl="" />
                                    </div>
                                    <div>
                                        <asp:Label ID="lblCarReplacement" Width="90px" runat="server" Text="" />
                                    </div>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="IsNCDInclude" Visible="false" HeaderText="NCD Protection Inclusive" />
                            <asp:ImageField ItemStyle-HorizontalAlign="Center" HeaderText="NCD Protection Inclusive"
                                DataImageUrlField="NCDIncludeUrl" SortExpression="IsNCDInclude">
                                <ItemStyle HorizontalAlign="Center"></ItemStyle>
                            </asp:ImageField>
                            <%--<asp:BoundField DataField="ModifiedDate" Visible="true" HeaderText="Date/Time" />--%>
                        </Columns>
                        <FooterStyle />
                        <PagerStyle />
                        <SelectedRowStyle />
                        <HeaderStyle CssClass="admin_gridheader" />
                        <EditRowStyle />
                        <AlternatingRowStyle CssClass="admin_gridodd" />
                        <RowStyle CssClass="admin_grideven" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="sqlDsCarInsurancePackage" runat="server" ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>"
                        SelectCommand="sprocCarInsuranceSelectItemSelectSingleItem" SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <asp:Parameter Name="CISelectItemId" Type="Int64" DefaultValue="0" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                    <hr />
                    <asp:GridView ID="grvProfile" runat="server" AllowPaging="True" AllowSorting="false"
                        PageSize="30" AutoGenerateColumns="False" DataKeyNames="ProfileID,RefCEUserId"
                        CellSpacing="3" CellPadding="3" Width="100%" CssClass="admin_gridstyle" PagerStyle-CssClass="pgr"
                        EmptyDataText="There are no data records to display." GridLines="None" DataSourceID="sqlDsProfile"
                        OnRowDataBound="grvProfile_RowDataBound">
                        <Columns>
                            <%--<asp:BoundField DataField="ProfileID" HeaderText="ProfileID" SortExpression="ProfileID"
                                InsertVisible="False" ReadOnly="True" />
                            <asp:BoundField DataField="Salutation" HeaderText="Salutation" SortExpression="Salutation" />--%>
                            <%--<asp:BoundField DataField="IDNOType" HeaderText="IDNOType" SortExpression="IDNOType" />
                            <asp:BoundField DataField="IDNO" HeaderText="IDNO" SortExpression="IDNO" />
                            <asp:BoundField DataField="HighEducation" HeaderText="HighEducation" SortExpression="HighEducation" />
                            <asp:BoundField DataField="Nationality" HeaderText="Nationality" SortExpression="Nationality" />
                            <asp:BoundField DataField="MontlyIncome" HeaderText="MontlyIncome" SortExpression="MontlyIncome" />
                            <asp:BoundField DataField="OtherIncome" HeaderText="OtherIncome" SortExpression="OtherIncome" />
                            <asp:BoundField DataField="JobNature" HeaderText="JobNature" SortExpression="JobNature" />
                            --%><%--<asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" />
                            <asp:BoundField DataField="RefCEUserId" HeaderText="RefCEUserId" ReadOnly="True"
                                SortExpression="RefCEUserId" />--%>
                            <%--<asp:BoundField DataField="CreatedDate" HeaderText="CreatedDate" 
                                SortExpression="CreatedDate" />--%>
                            <asp:TemplateField HeaderText="FirstName" SortExpression="FirstName">
                                <ItemTemplate>
                                    <asp:Label ID="lblFirstName" runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="SurName" SortExpression="SurName">
                                <ItemTemplate>
                                    <asp:Label ID="lblSurName" runat="server"></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="DOB" HeaderText="DOB" SortExpression="DOB" />
                            <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
                            <asp:BoundField DataField="MaritalStatus" HeaderText="MaritalStatus" SortExpression="MaritalStatus" />
                            <%--<asp:BoundField DataField="OccupationType" HeaderText="OccupationType" SortExpression="OccupationType" />--%>
                            <asp:BoundField DataField="Occupation" HeaderText="Occupation" SortExpression="Occupation" />
                            <asp:BoundField DataField="YearDriveSg" HeaderText="YearDriveSg" SortExpression="YearDriveSg" />
                            <asp:BoundField DataField="ModifiedDate" HeaderText="ModifiedDate" SortExpression="ModifiedDate" />
                        </Columns>
                        <FooterStyle />
                        <PagerStyle />
                        <SelectedRowStyle />
                        <HeaderStyle CssClass="admin_gridheader" />
                        <EditRowStyle />
                        <AlternatingRowStyle CssClass="admin_gridodd" />
                        <RowStyle CssClass="admin_grideven" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="sqlDsProfile" runat="server" ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>"
                        SelectCommand="sprocUserProfileReportSelectSingleItem" SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <%--<asp:ControlParameter ControlID="grvCarInsuranceResult" Name="CECarId" PropertyName="SelectedValue"
                                Type="Int64" />--%>
                            <asp:Parameter Name="RefCEUserId" Type="Int64" DefaultValue="0" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                    <hr />
                    <asp:GridView ID="grvCarDetail" runat="server" AllowPaging="True" AllowSorting="false"
                        PageSize="30" AutoGenerateColumns="False" DataKeyNames="CECarId" CellSpacing="3"
                        CellPadding="3" Width="100%" CssClass="admin_gridstyle" PagerStyle-CssClass="pgr"
                        EmptyDataText="There are no data records to display." GridLines="None" DataSourceID="sqlDsCarDetail">
                        <Columns>
                            <%--<asp:BoundField DataField="CECarId" HeaderText="CECarId" InsertVisible="False" ReadOnly="True"
                                SortExpression="CECarId" />--%>
                            <%--<asp:BoundField DataField="CarMakeId" HeaderText="CarMakeId" SortExpression="CarMakeId" />
                            <asp:BoundField DataField="CarModelId" HeaderText="CarModelId" SortExpression="CarModelId" />--%>
                            <asp:BoundField DataField="MakeModelDesc" HeaderText="MakeModelDesc" SortExpression="MakeModelDesc" />
                            <asp:BoundField DataField="ManufactYear" HeaderText="ManufactYear" SortExpression="ManufactYear" />
                            <asp:BoundField DataField="RegYear" HeaderText="RegYear" SortExpression="RegYear" />
                            <asp:CheckBoxField DataField="IsPeak" HeaderText="IsPeak" SortExpression="IsPeak" />
                            <asp:CheckBoxField DataField="IsParalleImport" HeaderText="IsParalleImport" SortExpression="IsParalleImport" />
                            <asp:BoundField DataField="SeatCapacity" Visible="true" HeaderText="SeatCapacity"
                                SortExpression="SeatCapacity" />
                            <%--<asp:BoundField DataField="Status" HeaderStyle-Width="80" HeaderText="Status" SortExpression="Status">
                                <HeaderStyle Width="80px"></HeaderStyle>
                            </asp:BoundField>--%>
                            <%--<asp:BoundField DataField="RefCEUserId" HeaderStyle-Width="80" HeaderText="RefCEUserId"
                                SortExpression="RefCEUserId">
                                <HeaderStyle Width="80px"></HeaderStyle>
                            </asp:BoundField>--%>
                            <%--<asp:BoundField DataField="CreatedDate" HeaderText="CreatedDate" SortExpression="CreatedDate" />--%>
                            <asp:BoundField DataField="ModifiedDate" HeaderText="Date/Time" SortExpression="ModifiedDate" />
                        </Columns>
                        <FooterStyle />
                        <PagerStyle />
                        <SelectedRowStyle />
                        <HeaderStyle CssClass="admin_gridheader" />
                        <EditRowStyle />
                        <AlternatingRowStyle CssClass="admin_gridodd" />
                        <RowStyle CssClass="admin_grideven" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="sqlDsCarDetail" runat="server" ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>"
                        SelectCommand="sprocCarDetailReportSelectSingleItem" SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <asp:Parameter Name="CECarId" Type="Int64" DefaultValue="0" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                    <hr />
                    <asp:GridView ID="grvPolicy" runat="server" AllowPaging="True" AllowSorting="false"
                        PageSize="30" AutoGenerateColumns="False" DataKeyNames="CECarPolicyID,CECarId"
                        CellSpacing="3" CellPadding="3" Width="100%" CssClass="admin_gridstyle" PagerStyle-CssClass="pgr"
                        EmptyDataText="There are no data records to display." GridLines="None" DataSourceID="sqlDsPolicy">
                        <Columns>
                            <%--<asp:BoundField DataField="CECarPolicyID" HeaderText="CECarPolicyID" SortExpression="CECarPolicyID"
                                InsertVisible="False" ReadOnly="True" />
                            <asp:BoundField DataField="CECarId" HeaderText="CECarId" SortExpression="CECarId"
                                ReadOnly="True" />--%>
                            <%--<asp:BoundField DataField="TypeOfCoverage" HeaderText="TypeOfCoverage" SortExpression="TypeOfCoverage" />--%>
                            <asp:BoundField DataField="CoverageCommenceDate" HeaderText="Coverage Commence Date"
                                SortExpression="CoverageCommenceDate" />
                            <asp:BoundField DataField="NCDPercent" HeaderText="NCDPercent" SortExpression="NCDPercent" />
                            <asp:CheckBoxField DataField="IsClaimLastThreeYear" HeaderText="Claim Last Three Year"
                                SortExpression="IsClaimLastThreeYear" />
                            <%--<asp:BoundField DataField="ExcessPreference" Visible="true" HeaderText="ExcessPreference"
                                SortExpression="ExcessPreference" />--%>
                            <asp:CheckBoxField DataField="IsOffDriveCom" HeaderText="OFD" SortExpression="IsOffDriveCom" />
                            <%--<asp:BoundField DataField="TPDP" HeaderText="TPDP" SortExpression="TPDP" />--%>
                            <%--<asp:CheckBoxField DataField="IsNCDProtection" HeaderText="IsNCDProtection" SortExpression="IsNCDProtection" />--%>
                            <%--<asp:CheckBoxField DataField="IsChangeVE" HeaderText="IsChangeVE" SortExpression="IsChangeVE" />--%>
                            <%--<asp:BoundField DataField="IncDesExcess" HeaderText="IncDesExcess" SortExpression="IncDesExcess" />--%>
                            <%--<asp:CheckBoxField DataField="IsMainDriver" HeaderText="IsMainDriver" SortExpression="IsMainDriver" />--%>
                            <asp:CheckBoxField DataField="IsAddDriver" HeaderText="Additional Driver" SortExpression="IsAddDriver" />
                            <asp:BoundField DataField="NoOfDriver" HeaderText="No. Of Driver" SortExpression="NoOfDriver" />
                            <%--<asp:BoundField DataField="RefCEUserId" HeaderText="RefCEUserId" SortExpression="RefCEUserId" />--%>
                            <%--<asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" />--%>
                            <%--<asp:BoundField DataField="CreatedDate" HeaderText="CreatedDate" SortExpression="CreatedDate" />--%>
                            <asp:BoundField DataField="ModifiedDate" HeaderText="Date/Time" SortExpression="ModifiedDate" />
                        </Columns>
                        <FooterStyle />
                        <PagerStyle />
                        <SelectedRowStyle />
                        <HeaderStyle CssClass="admin_gridheader" />
                        <EditRowStyle />
                        <AlternatingRowStyle CssClass="admin_gridodd" />
                        <RowStyle CssClass="admin_grideven" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="sqlDsPolicy" runat="server" ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>"
                        SelectCommand="sprocCarPolicyReportSelectSingleItem" SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <%--<asp:ControlParameter ControlID="grvCarInsuranceResult" Name="CECarId" PropertyName="SelectedValue"
                                Type="Int64" />--%>
                            <asp:Parameter Name="CECarId" Type="Int64" DefaultValue="0" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                    <asp:ImageButton OnClientClick="javascript:return confirm('Are you sure to go back?');"
                        ID="ibtBack" runat="server" ImageUrl="~/Provider/images/buttons/back1.gif" OnClick="ibtBack_Click" />
                </td>
            </tr>
        </table>
    </div>
</asp:Content>
